if exists(select name from sysobjects where name = 'sp_GroupNewsGetInfo')
	drop proc sp_GroupNewsGetInfo
go
/*-- =============================================
	Created by: HP
	Created on: 2014-03-23 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_GroupNewsGetInfo.sql
*/-- =============================================

CREATE PROCEDURE sp_GroupNewsGetInfo
			
	@Id      		INT
AS
BEGIN	
	SELECT
		a.[Id],
		a.[Name],
		a.[Tag],
		a.[Title],
		a.[Description],
		a.[Keyword],
		a.[Ord],
		a.[Priority],
		a.[Index],
		a.[Active],
		a.[Lang],
		a.[ParentId]
	FROM
		GroupNews a
	WHERE
		    a.[Id]       = @Id;
END
GO
